package com.trkj.dao.hjj;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Confirmaffair;
//员工表
import com.trkj.pojo.Leaveconfirm;
public interface ConfirmaffairDAO extends CrudRepository<Confirmaffair,Long>{
	@Query("select c FROM Confirmaffair c  inner join c.staffInformation z inner join c.holiday h inner join c.affaircategory p")
	public List<Confirmaffair> findalllo(Pageable p);
	
}
